
/****** Object:  StoredProcedure [dbo].[web_del_prot_items]    Script Date: 10/19/2013 09:20:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'web_del_prot_items')
DROP PROCEDURE web_del_prot_items
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[web_del_prot_items]
	@X02_data varchar(10)
AS	
BEGIN
	SET NOCOUNT ON
	
	delete from x02_prot where X02_data=cast(@X02_data as date)

 
END

GO



